#!/usr/bin/python3

import postgresql
sql1 = 'CREATE TABLE upload_tbl1(id SERIAL PRIMARY KEY,name VARCHAR(20) NOT NULL, content TEXT, upload_date timestamp without time zone)'
db1 = postgresql.open('pq://user1:user049@localhost:5432/udb1')
db1.execute(sql1)
db1.close()
